package com.pv.bfc.constants;

public class BriefcaseConstants {

	public static final String INSERT_BREIFCAEUSER_SQL = "INSERT INTO BRIEFCASEUSER(USER_ID,USERNAME,FIRST_NAME,LAST_NAME,EMAIL,PASSWORD) "
			+ "VALUES (?,?,?,?,?,?)";

	public static final String INSERT_FOLDER_SQL = "INSERT INTO FOLDER(ID,USERNAME,FOLDER_NAME,DESCRIPTION,CREATION_DATE) "
			+ "VALUES (?,?,?,?,?)";

	public static final String INSERT_DOCUMENT_SQL = "INSERT INTO DOCUMENT(DOC_ID,DOC_NAME,DOC_SIZE) "
			+ "VALUES(?,?,?)";

	public static final String INSERT_FOLDER_DOCUMENT_SQL = "INSERT INTO FOLDER_DOCUMENT (DOC_ID,FOLDER_ID)"
			+ "values (?, ?)";

	public static final String USER_BY_NAME_SQL = "FROM BriefcaseUser a WHERE a.userName=";

	public static final String USER_BY_EMAILID_SQL = "FROM BriefcaseUser WHERE EMAIL=";

	public static final String ROLES_BY_USERNAME_SQL = "SELECT ROLE FROM BRIEFCASE_ROLES WHERE USERNAME = ";

	public static final String USER_PROFILE = "FROM UserProfile a WHERE a.userName = ";

}
